<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>39.5. Zend_Session_SaveHandler_DbTable</title>
<link rel="stylesheet" href="dbstyle.css" type="text/css">
<meta name="generator" content="DocBook XSL Stylesheets V1.72.0">
<link rel="start" href="index.html" title="Programmer's Reference Guide">
<link rel="up" href="zend.session.html" title="Chapter 39. Zend_Session">
<link rel="prev" href="zend.session.global_session_management.html" title="39.4. Global Session Management">
<link rel="next" href="zend.soap.html" title="Chapter 40. Zend_Soap">
<link rel="chapter" href="introduction.html" title="Chapter 1. Introduction to Zend Framework">
<link rel="chapter" href="zend.acl.html" title="Chapter 2. Zend_Acl">
<link rel="chapter" href="zend.auth.html" title="Chapter 3. Zend_Auth">
<link rel="chapter" href="zend.cache.html" title="Chapter 4. Zend_Cache">
<link rel="chapter" href="zend.config.html" title="Chapter 5. Zend_Config">
<link rel="chapter" href="zend.console.getopt.html" title="Chapter 6. Zend_Console_Getopt">
<link rel="chapter" href="zend.controller.html" title="Chapter 7. Zend_Controller">
<link rel="chapter" href="zend.currency.html" title="Chapter 8. Zend_Currency">
<link rel="chapter" href="zend.date.html" title="Chapter 9. Zend_Date">
<link rel="chapter" href="zend.db.html" title="Chapter 10. Zend_Db">
<link rel="chapter" href="zend.debug.html" title="Chapter 11. Zend_Debug">
<link rel="chapter" href="zend.dojo.html" title="Chapter 12. Zend_Dojo">
<link rel="chapter" href="zend.dom.html" title="Chapter 13. Zend_Dom">
<link rel="chapter" href="zend.exception.html" title="Chapter 14. Zend_Exception">
<link rel="chapter" href="zend.feed.html" title="Chapter 15. Zend_Feed">
<link rel="chapter" href="zend.filter.html" title="Chapter 16. Zend_Filter">
<link rel="chapter" href="zend.form.html" title="Chapter 17. Zend_Form">
<link rel="chapter" href="zend.gdata.html" title="Chapter 18. Zend_Gdata">
<link rel="chapter" href="zend.http.html" title="Chapter 19. Zend_Http">
<link rel="chapter" href="zend.infocard.html" title="Chapter 20. Zend_InfoCard">
<link rel="chapter" href="zend.json.html" title="Chapter 21. Zend_Json">
<link rel="chapter" href="zend.layout.html" title="Chapter 22. Zend_Layout">
<link rel="chapter" href="zend.ldap.html" title="Chapter 23. Zend_Ldap">
<link rel="chapter" href="zend.loader.html" title="Chapter 24. Zend_Loader">
<link rel="chapter" href="zend.locale.html" title="Chapter 25. Zend_Locale">
<link rel="chapter" href="zend.log.html" title="Chapter 26. Zend_Log">
<link rel="chapter" href="zend.mail.html" title="Chapter 27. Zend_Mail">
<link rel="chapter" href="zend.measure.html" title="Chapter 28. Zend_Measure">
<link rel="chapter" href="zend.memory.html" title="Chapter 29. Zend_Memory">
<link rel="chapter" href="zend.mime.html" title="Chapter 30. Zend_Mime">
<link rel="chapter" href="zend.openid.html" title="Chapter 31. Zend_OpenId">
<link rel="chapter" href="zend.paginator.html" title="Chapter 32. Zend_Paginator">
<link rel="chapter" href="zend.pdf.html" title="Chapter 33. Zend_Pdf">
<link rel="chapter" href="zend.registry.html" title="Chapter 34. Zend_Registry">
<link rel="chapter" href="zend.rest.html" title="Chapter 35. Zend_Rest">
<link rel="chapter" href="zend.search.lucene.html" title="Chapter 36. Zend_Search_Lucene">
<link rel="chapter" href="zend.server.html" title="Chapter 37. Zend_Server">
<link rel="chapter" href="zend.service.html" title="Chapter 38. Zend_Service">
<link rel="chapter" href="zend.session.html" title="Chapter 39. Zend_Session">
<link rel="chapter" href="zend.soap.html" title="Chapter 40. Zend_Soap">
<link rel="chapter" href="zend.test.html" title="Chapter 41. Zend_Test">
<link rel="chapter" href="zend.text.html" title="Chapter 42. Zend_Text">
<link rel="chapter" href="zend.timesync.html" title="Chapter 43. Zend_TimeSync">
<link rel="chapter" href="zend.translate.html" title="Chapter 44. Zend_Translate">
<link rel="chapter" href="zend.uri.html" title="Chapter 45. Zend_Uri">
<link rel="chapter" href="zend.validate.html" title="Chapter 46. Zend_Validate">
<link rel="chapter" href="zend.version.html" title="Chapter 47. Zend_Version">
<link rel="chapter" href="zend.view.html" title="Chapter 48. Zend_View">
<link rel="chapter" href="zend.xmlrpc.html" title="Chapter 49. Zend_XmlRpc">
<link rel="appendix" href="requirements.html" title="Appendix A. Zend Framework Requirements">
<link rel="appendix" href="coding-standard.html" title="Appendix B. Zend Framework Coding Standard for PHP">
<link rel="appendix" href="copyrights.html" title="Appendix C. Copyright Information">
<link rel="index" href="the.index.html" title="Index">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader"><table width="100%" summary="Navigation header">
<tr><th colspan="3" align="center">39.5. Zend_Session_SaveHandler_DbTable</th></tr>
<tr>
<td width="20%" align="left">
<a accesskey="p" href="zend.session.global_session_management.html">Prev</a> </td>
<th width="60%" align="center">Chapter 39. Zend_Session</th>
<td width="20%" align="right"> <a accesskey="n" href="zend.soap.html">Next</a>
</td>
</tr>
</table></div>
<div class="sect1" lang="en">
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
<a name="zend.session.savehandler.dbtable"></a>39.5. Zend_Session_SaveHandler_DbTable</h2></div></div></div>
<p>
		The basic setup for Zend_Session_SaveHandler_DbTable must at least
		have four columns, denoted in the config array/Zend_Config object: 
		primary, which is the primary key and defaults to just the session
		id which by default is a string of length 32;
		modified, which is the unix timestamp of the last modified date;
		lifetime, which is the lifetime of the session (modified + lifetime &gt; time());
		and data, which is the serialized data stored in the session
	</p>
<div class="example">
<a name="zend.session.savehandler.dbtable.basic"></a><p class="title"><b>Example 39.18. Basic Setup</b></p>
<div class="example-contents">
<pre class="programlisting">
CREATE TABLE `session` (
  `id` char(32),
  `modified` int,
  `lifetime` int,
  `data` text,
  PRIMARY KEY (`id`)
);
?&gt;</pre>
<pre class="programlisting">&lt;?php
//get your database connection ready
$db = Zend_Db::factory('Pdo_Mysql', array(
	'host'		=&gt;'example.com',
	'username'	=&gt; 'dbuser',
	'password'	=&gt; '******',
	'dbname'	=&gt; 'dbname'
));

//you can either set the Zend_Db_Table default adapter
//or you can pass the db connection straight to the save handler $config
Zend_Db_Table_Abstract::setDefaultAdapter($db);
$config = array(
	'name'           =&gt; 'session', 
	'primary'        =&gt; 'id', 
	'modifiedColumn' =&gt; 'modified',
	'dataColumn'     =&gt; 'data',
	'lifetimeColumn' =&gt; 'lifetime' 
); 

//create your Zend_Session_SaveHandler_DbTable and 
//set the save handler for Zend_Session
Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable($config));

//start your session! 
Zend_Session::start();

//now you can use Zend_Session like any other time
?&gt;</pre>
</div>
</div>
<br class="example-break"><p>
		You can also use Multiple Columns in your primary key for
		Zend_Session_SaveHandler_DbTable.
	</p>
<div class="example">
<a name="zend.session.savehandler.dbtable.multi-column-key"></a><p class="title"><b>Example 39.19. Using a Multi-Column Primary Key</b></p>
<div class="example-contents">
<pre class="programlisting">
CREATE TABLE `session` (
	`session_id` char(32) NOT NULL,
	`save_path` varchar(32) NOT NULL,
	`name` varchar(32) NOT NULL DEFAULT '',
	`modified` int,
	`lifetime` int,
	`session_data` text,
	PRIMARY KEY (`Session_ID`, `save_path`, `name`)
);
?&gt;</pre>
<pre class="programlisting">&lt;?php
//setup your DB connection like before
//NOTE: this config is also passed to Zend_Db_Table so anything specific
//to the table can be put in the config as well
$config = array(
	'name'              =&gt; 'session', //table name as per Zend_Db_Table 
	'primary'           =&gt; array( 
		'session_id',   //the sessionID given by php 
		'save_path',    //session.save_path  
		'name',         //session name
	),
	'primaryAssignment' =&gt; array( //you must tell the save handler which columns you
	                              //are using as the primary key. ORDER IS IMPORTANT
		'sessionId',          //first column of the primary key is of the sessionID 
		'sessionSavePath',    //second column of the primary key is the save path 
		'sessionName',        //third column of the primary key is the session name 
	), 
	'modifiedColumn'    =&gt; 'modified',     //time the session should expire 
	'dataColumn'        =&gt; 'session_data', //serialized data
	'lifetimeColumn'    =&gt; 'lifetime',     //end of life for a specific record 
);

//Tell Zend_Session to use your Save Handler
Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable($config)); 

//start your session
Zend_Session::start();

//use Zend_Session as normal
?&gt;</pre>
</div>
</div>
<br class="example-break">
</div>
<div class="navfooter"><table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left">
<a accesskey="p" href="zend.session.global_session_management.html">Prev</a> </td>
<td width="20%" align="center"><a accesskey="u" href="zend.session.html">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="zend.soap.html">Next</a>
</td>
</tr>
<tr>
<td width="40%" align="left" valign="top">39.4. Global Session Management </td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top"> Chapter 40. Zend_Soap</td>
</tr>
</table></div>
<div class="revinfo"></div>
</body>
</html>
